<%-- 
    Document   : consultaclientes
    Created on : 5/11/2013, 06:56:56 PM
    Author     : Ari Mendez
--%>

<%@page import="java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<jsp:useBean class="clases.ControlDatos" id="cdatos" scope="session"></jsp:useBean>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Consulta de Clientes</title>
    </head>
    <body>

        <table border="1">
            <tr><th>ID</th><th>Nombre</th><th>Apellido</th>
                <th>Telefono</th><th>Direccion</th><th>Correo</th></tr>
        <%
            ResultSet result=cdatos.consultaClientes();
            while(result.next()){
                out.print("<tr>");
                out.print("<td>");
                out.print(result.getString(1));
                out.print("</td>");
                out.print("<td>");
                out.print(result.getString(2));
                out.print("</td>");
                out.print("<td>");
                out.print(result.getString(3));
                out.print("</td>");
                out.print("<td>");
                out.print(result.getString(4));
                out.print("</td>");
                out.print("<td>");
                out.print(result.getString(5));
                out.print("</td>");
                out.print("<td>");
                out.print(result.getString(6));
                out.print("</td>");
                out.print("</tr>");
            }
        %>
        </table>
    </body>
</html>
